﻿----------------------2011-4-19------------------------------------
/*
新增短信表
*/
CREATE TABLE [dbo].[SMS_OutGoingSMS](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[PhoneNumber] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[Content] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[CreatedBy] [int] NOT NULL,
	[CreatedDate] [datetime] NOT NULL,
	[DispatchId] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,
	[IsSent] [bit] NOT NULL,
	[SentDate] [datetime] NULL,
	[Message_SN] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,
	[Error_Message] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,
 CONSTRAINT [PK_OutGoingSMS] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
 
---------------2011-5-14------------------
/*开机工作单修改*/

alter table Jci_Dis_WorkingVendorFileItem add CustomerName varchar(100)
alter table Jci_Dis_WorkingVendorFileItem add Phone varchar(100)
alter table Jci_Dis_WorkingVendorFileItem add CustomerType varchar(50)
alter table Jci_Dis_WorkingVendorFileItem add Address varchar(2000)

alter table Jci_Dis_WorkingVendorFileItem add SalesUnit varchar(200)
alter table Jci_Dis_WorkingVendorFileItem add TicketNo varchar(1000)
alter table Jci_Dis_WorkingVendorFileItem add TicketDate varchar(50)
alter table Jci_Dis_WorkingVendorFileItem add BPNo varchar(1000)

alter table Jci_Dis_WorkingVendorFileItem add InMType varchar(1000)
alter table Jci_Dis_WorkingVendorFileItem add InMNO varchar(1000)
alter table Jci_Dis_WorkingVendorFileItem add OutMType varchar(500)
alter table Jci_Dis_WorkingVendorFileItem add OutMNO varchar(1000)

alter table Jci_Dis_WorkingVendorFileItem add UnitName varchar(1000)
alter table Jci_Dis_WorkingVendorFileItem add VenderName varchar(100)
alter table Jci_Dis_WorkingVendorFileItem add DebugDate varchar(50)